use davit_gdait_db2
go

CREATE VIEW AllParameters 
AS
select i.DESCRIPTION as iDescription, i.ABBREVIATION as iAbbreviation, it.DESCRIPTION as itDescription, iv.VALUE as ivValue, up.PREFIX as upPrefix, u.NAME as uName, us.SYMBOL as usSymbol, ivt.VALUE_TYPE as ivtValueType, ivt.DATE as ivtDate from INDICATOR_VALUES iv
inner join INDICATOR_VALUE_TYPE ivt on ivt.ID = iv.VALUE_TYPE_FK
inner join INDICATOR i on i.ID=iv.INDICATOR_ID_FK
inner join INDICATOR_TYPE it on it.ID = i.INDICATOR_TYPE_FK
inner join UNIT u on u.ID = i.UNIT_FK 
inner join UNIT_PREFIX up on up.ID=u.UNIT_PREFIX_ID_FK
inner join UNIT_SYMBOL us on us.ID = u.SYMBOL_ID_FK 